Overview

Brought to you by YData

Dataset statistics

Number of variables	16
Number of observations	50000
Missing cells	3270
Missing cells (%)	0.4%
Total size in memory	6.5 MiB
Average record size in memory	136.0 B

Variable types

Numeric	6
Text	10

Alerts

`post_code` has 1150 (2.3%) missing values	Missing
`post_code_prefix` has 1150 (2.3%) missing values	Missing
`country` has 750 (1.5%) missing values	Missing
`venue_server_id` is highly skewed (γ1 = 21.7836194)	Skewed
`performance_reserved` has 47703 (95.4%) zeros	Zeros

Reproduction

Analysis started	2025-11-02 18:26:27.412027
Analysis finished	2025-11-02 18:26:29.564685
Duration	2.15 seconds
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

customer_id
Real number (ℝ)

Distinct	40463
Distinct (%)	80.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	775855.542

Minimum	4
Maximum	1233429
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.2 KiB

Quantile statistics

Minimum	4
5-th percentile	56126.6
Q1	467353
median	894561.5
Q3	1114738.25
95-th percentile	1202578.05
Maximum	1233429
Range	1233425
Interquartile range (IQR)	647385.25

Descriptive statistics

Standard deviation	386092.5379
Coefficient of variation (CV)	0.4976345685
Kurtosis	-1.018343925
Mean	775855.542
Median Absolute Deviation (MAD)	255849
Skewness	-0.6096614659
Sum	3.87927771 × 10¹⁰
Variance	1.490674478 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
368937	52	0.1%
6	15	< 0.1%
305677	14	< 0.1%
15931	12	< 0.1%
363498	12	< 0.1%
96925	11	< 0.1%
1643	11	< 0.1%
907893	10	< 0.1%
16352	10	< 0.1%
597176	10	< 0.1%
Other values (40453)	49843	99.7%

Value	Count	Frequency (%)
4	2	< 0.1%
6	15	< 0.1%
15	1	< 0.1%
20	2	< 0.1%
24	1	< 0.1%

Value	Count	Frequency (%)
1233429	2	< 0.1%
1231175	3	< 0.1%
1231108	1	< 0.1%
1231100	1	< 0.1%
1231095	1	< 0.1%

post_code
Text

Missing

Distinct	32225
Distinct (%)	66.0%
Missing	1150
Missing (%)	2.3%
Memory size	781.2 KiB

Length

Max length	15
Median length	14
Mean length	7.162108495
Min length	1

Characters and Unicode

Total characters	349869
Distinct characters	72
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	22907 ?
Unique (%)	46.9%

Sample

1st row	PL5 3UB
2nd row	33100
3rd row	EH21 7BS
4th row	DD11 4BJ
5th row	HP5 1EG

Value	Count	Frequency (%)
eh4	1280	1.4%
eh6	1202	1.3%
eh10	1121	1.2%
eh3	1078	1.2%
eh7	1030	1.1%
eh12	881	0.9%
eh9	860	0.9%
eh11	839	0.9%
eh8	663	0.7%
eh14	585	0.6%
Other values (9051)	83797	89.8%

Most occurring characters

Value	Count	Frequency (%)
	44486	12.7%
1	28801	8.2%
E	23965	6.8%
H	22067	6.3%
2	16807	4.8%
4	13013	3.7%
3	12596	3.6%
5	11744	3.4%
6	11236	3.2%
0	10310	2.9%
Other values (62)	154844	44.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	349869	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	44486	12.7%
1	28801	8.2%
E	23965	6.8%
H	22067	6.3%
2	16807	4.8%
4	13013	3.7%
3	12596	3.6%
5	11744	3.4%
6	11236	3.2%
0	10310	2.9%
Other values (62)	154844	44.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	349869	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	44486	12.7%
1	28801	8.2%
E	23965	6.8%
H	22067	6.3%
2	16807	4.8%
4	13013	3.7%
3	12596	3.6%
5	11744	3.4%
6	11236	3.2%
0	10310	2.9%
Other values (62)	154844	44.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	349869	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	44486	12.7%
1	28801	8.2%
E	23965	6.8%
H	22067	6.3%
2	16807	4.8%
4	13013	3.7%
3	12596	3.6%
5	11744	3.4%
6	11236	3.2%
0	10310	2.9%
Other values (62)	154844	44.3%

post_code_prefix
Text

Missing

Distinct	9189
Distinct (%)	18.8%
Missing	1150
Missing (%)	2.3%
Memory size	781.2 KiB

Length

Max length	10
Median length	5
Mean length	5.338423746
Min length	1

Characters and Unicode

Total characters	260782
Distinct characters	71
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3660 ?
Unique (%)	7.5%

Sample

1st row	PL5 3
2nd row	33100
3rd row	EH21 7
4th row	DD11 4
5th row	HP5 1

Value	Count	Frequency (%)
5	5296	5.7%
1	5232	5.6%
2	4749	5.1%
6	4616	4.9%
4	4569	4.9%
8	4381	4.7%
9	4347	4.7%
3	4165	4.5%
7	4075	4.4%
0	2903	3.1%
Other values (5163)	48987	52.5%

Most occurring characters

Value	Count	Frequency (%)
	44470	17.1%
1	28754	11.0%
E	18038	6.9%
2	16750	6.4%
H	16314	6.3%
4	12962	5.0%
3	12530	4.8%
5	11689	4.5%
6	11192	4.3%
0	10257	3.9%
Other values (61)	77826	29.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	260782	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	44470	17.1%
1	28754	11.0%
E	18038	6.9%
2	16750	6.4%
H	16314	6.3%
4	12962	5.0%
3	12530	4.8%
5	11689	4.5%
6	11192	4.3%
0	10257	3.9%
Other values (61)	77826	29.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	260782	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	44470	17.1%
1	28754	11.0%
E	18038	6.9%
2	16750	6.4%
H	16314	6.3%
4	12962	5.0%
3	12530	4.8%
5	11689	4.5%
6	11192	4.3%
0	10257	3.9%
Other values (61)	77826	29.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	260782	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	44470	17.1%
1	28754	11.0%
E	18038	6.9%
2	16750	6.4%
H	16314	6.3%
4	12962	5.0%
3	12530	4.8%
5	11689	4.5%
6	11192	4.3%
0	10257	3.9%
Other values (61)	77826	29.8%

country
Text

Missing

Distinct	92
Distinct (%)	0.2%
Missing	750
Missing (%)	1.5%
Memory size	781.2 KiB

Length

Max length	38
Median length	14
Mean length	13.64186802
Min length	4

Characters and Unicode

Total characters	671862
Distinct characters	53
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	20 ?
Unique (%)	< 0.1%

Sample

1st row	United Kingdom
2nd row	Finland
3rd row	United Kingdom
4th row	United Kingdom
5th row	United Kingdom

Value	Count	Frequency (%)
united	46693	48.5%
kingdom	44786	46.6%
states	1868	1.9%
australia	415	0.4%
ireland	340	0.4%
germany	235	0.2%
canada	211	0.2%
netherlands	151	0.2%
france	118	0.1%
norway	102	0.1%
Other values (99)	1274	1.3%

Most occurring characters

Value	Count	Frequency (%)
n	93200	13.9%
d	92520	13.8%
i	92438	13.8%
t	51331	7.6%
e	50293	7.5%
	46943	7.0%
U	46699	7.0%
m	45179	6.7%
o	45123	6.7%
g	44957	6.7%
Other values (43)	63179	9.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	671862	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	93200	13.9%
d	92520	13.8%
i	92438	13.8%
t	51331	7.6%
e	50293	7.5%
	46943	7.0%
U	46699	7.0%
m	45179	6.7%
o	45123	6.7%
g	44957	6.7%
Other values (43)	63179	9.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	671862	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	93200	13.9%
d	92520	13.8%
i	92438	13.8%
t	51331	7.6%
e	50293	7.5%
	46943	7.0%
U	46699	7.0%
m	45179	6.7%
o	45123	6.7%
g	44957	6.7%
Other values (43)	63179	9.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	671862	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	93200	13.9%
d	92520	13.8%
i	92438	13.8%
t	51331	7.6%
e	50293	7.5%
	46943	7.0%
U	46699	7.0%
m	45179	6.7%
o	45123	6.7%
g	44957	6.7%
Other values (43)	63179	9.4%

transaction_id
Text

Distinct	46908
Distinct (%)	93.8%
Missing	0
Missing (%)	0.0%
Memory size	781.2 KiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	550000
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	44411 ?
Unique (%)	88.8%

Sample

1st row	180:2755036
2nd row	180:2971362
3rd row	180:3222183
4th row	180:3055761
5th row	180:2835129

Value	Count	Frequency (%)
180:2830706	7	< 0.1%
180:2817474	6	< 0.1%
180:2736476	6	< 0.1%
180:2717038	6	< 0.1%
180:2852651	6	< 0.1%
180:2727364	6	< 0.1%
180:2714963	6	< 0.1%
180:2723121	6	< 0.1%
180:2721171	6	< 0.1%
180:2715569	6	< 0.1%
Other values (46898)	49939	99.9%

Most occurring characters

Value	Count	Frequency (%)
8	83223	15.1%
1	82490	15.0%
0	82158	14.9%
2	60121	10.9%
:	50000	9.1%
3	48280	8.8%
7	35937	6.5%
9	32306	5.9%
6	26001	4.7%
4	25005	4.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	550000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
8	83223	15.1%
1	82490	15.0%
0	82158	14.9%
2	60121	10.9%
:	50000	9.1%
3	48280	8.8%
7	35937	6.5%
9	32306	5.9%
6	26001	4.7%
4	25005	4.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	550000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
8	83223	15.1%
1	82490	15.0%
0	82158	14.9%
2	60121	10.9%
:	50000	9.1%
3	48280	8.8%
7	35937	6.5%
9	32306	5.9%
6	26001	4.7%
4	25005	4.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	550000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
8	83223	15.1%
1	82490	15.0%
0	82158	14.9%
2	60121	10.9%
:	50000	9.1%
3	48280	8.8%
7	35937	6.5%
9	32306	5.9%
6	26001	4.7%
4	25005	4.5%

no_of_tickets
Real number (ℝ)

Distinct	34
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.25654

Minimum	1
Maximum	80
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	4
Maximum	80
Range	79
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.503706238
Coefficient of variation (CV)	0.666376948
Kurtosis	227.2034188
Mean	2.25654
Median Absolute Deviation (MAD)	0
Skewness	8.010635296
Sum	112827
Variance	2.261132451
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
2	25717	51.4%
1	12459	24.9%
3	4842	9.7%
4	4521	9.0%
5	1044	2.1%
6	719	1.4%
7	219	0.4%
8	186	0.4%
10	80	0.2%
9	61	0.1%
Other values (24)	152	0.3%

Value	Count	Frequency (%)
1	12459	24.9%
2	25717	51.4%
3	4842	9.7%
4	4521	9.0%
5	1044	2.1%

Value	Count	Frequency (%)
80	1	< 0.1%
51	1	< 0.1%
50	1	< 0.1%
41	1	< 0.1%
33	1	< 0.1%

performance_date
Text

Distinct	3945
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Memory size	781.2 KiB

Length

Max length	16
Median length	16
Mean length	16
Min length	16

Characters and Unicode

Total characters	800000
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	528 ?
Unique (%)	1.1%

Sample

1st row	05/08/2019 13:00
2nd row	07/08/2019 16:30
3rd row	22/08/2019 19:00
4th row	12/08/2019 16:30
5th row	03/08/2019 23:40

Value	Count	Frequency (%)
17/08/2019	2958	3.0%
24/08/2019	2807	2.8%
10/08/2019	2680	2.7%
16/08/2019	2508	2.5%
21:00	2507	2.5%
23/08/2019	2322	2.3%
06/08/2019	2205	2.2%
18/08/2019	2180	2.2%
15/08/2019	2162	2.2%
05/08/2019	2082	2.1%
Other values (202)	75589	75.6%

Most occurring characters

Value	Count	Frequency (%)
0	182867	22.9%
1	125365	15.7%
/	100000	12.5%
2	91187	11.4%
9	60025	7.5%
8	58582	7.3%
	50000	6.2%
:	50000	6.2%
3	25422	3.2%
5	23549	2.9%
Other values (3)	33003	4.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	800000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	182867	22.9%
1	125365	15.7%
/	100000	12.5%
2	91187	11.4%
9	60025	7.5%
8	58582	7.3%
	50000	6.2%
:	50000	6.2%
3	25422	3.2%
5	23549	2.9%
Other values (3)	33003	4.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	800000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	182867	22.9%
1	125365	15.7%
/	100000	12.5%
2	91187	11.4%
9	60025	7.5%
8	58582	7.3%
	50000	6.2%
:	50000	6.2%
3	25422	3.2%
5	23549	2.9%
Other values (3)	33003	4.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	800000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	182867	22.9%
1	125365	15.7%
/	100000	12.5%
2	91187	11.4%
9	60025	7.5%
8	58582	7.3%
	50000	6.2%
:	50000	6.2%
3	25422	3.2%
5	23549	2.9%
Other values (3)	33003	4.1%

event
Text

Distinct	2919
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Memory size	781.2 KiB

Length

Max length	205
Median length	81
Mean length	25.78152
Min length	1

Characters and Unicode

Total characters	1289076
Distinct characters	102
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	361 ?
Unique (%)	0.7%

Sample

1st row	Splash Test Dummies
2nd row	Adventures of the Improvised Sherlock Holmes
3rd row	Kai Samra: Underclass
4th row	The Black Blues Brothers
5th row	Massaoke Mixtape

Value	Count	Frequency (%)
the	12935	6.0%
of	4930	2.3%
and	3619	1.7%
a	2919	1.3%
in	2321	1.1%
musical	1858	0.9%
to	1749	0.8%
live	1654	0.8%
	1652	0.8%
show	1469	0.7%
Other values (5040)	181393	83.8%

Most occurring characters

Value	Count	Frequency (%)
	167656	13.0%
e	110542	8.6%
o	76006	5.9%
a	73951	5.7%
n	67939	5.3%
i	66207	5.1%
r	65333	5.1%
t	57018	4.4%
s	56264	4.4%
l	44668	3.5%
Other values (92)	503492	39.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1289076	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	167656	13.0%
e	110542	8.6%
o	76006	5.9%
a	73951	5.7%
n	67939	5.3%
i	66207	5.1%
r	65333	5.1%
t	57018	4.4%
s	56264	4.4%
l	44668	3.5%
Other values (92)	503492	39.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1289076	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	167656	13.0%
e	110542	8.6%
o	76006	5.9%
a	73951	5.7%
n	67939	5.3%
i	66207	5.1%
r	65333	5.1%
t	57018	4.4%
s	56264	4.4%
l	44668	3.5%
Other values (92)	503492	39.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1289076	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	167656	13.0%
e	110542	8.6%
o	76006	5.9%
a	73951	5.7%
n	67939	5.3%
i	66207	5.1%
r	65333	5.1%
t	57018	4.4%
s	56264	4.4%
l	44668	3.5%
Other values (92)	503492	39.1%

event_type
Text

Distinct	10
Distinct (%)	< 0.1%
Missing	220
Missing (%)	0.4%
Memory size	781.2 KiB

Length

Max length	33
Median length	19
Mean length	10.01275613
Min length	5

Characters and Unicode

Total characters	498435
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Children's Shows
2nd row	Comedy
3rd row	Comedy
4th row	Dance Physical Theatre and Circus
5th row	Music

Value	Count	Frequency (%)
comedy	22126	28.4%
theatre	16492	21.2%
and	8438	10.8%
dance	4278	5.5%
physical	4278	5.5%
circus	4278	5.5%
music	3986	5.1%
variety	2136	2.7%
cabaret	2136	2.7%
children's	2058	2.6%
Other values (7)	7680	9.9%

Most occurring characters

Value	Count	Frequency (%)
e	68639	13.8%
a	43942	8.8%
d	33238	6.7%
C	30598	6.1%
r	29740	6.0%
y	28540	5.7%
	28106	5.6%
o	25477	5.1%
h	24947	5.0%
m	22126	4.4%
Other values (23)	163082	32.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	498435	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	68639	13.8%
a	43942	8.8%
d	33238	6.7%
C	30598	6.1%
r	29740	6.0%
y	28540	5.7%
	28106	5.6%
o	25477	5.1%
h	24947	5.0%
m	22126	4.4%
Other values (23)	163082	32.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	498435	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	68639	13.8%
a	43942	8.8%
d	33238	6.7%
C	30598	6.1%
r	29740	6.0%
y	28540	5.7%
	28106	5.6%
o	25477	5.1%
h	24947	5.0%
m	22126	4.4%
Other values (23)	163082	32.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	498435	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	68639	13.8%
a	43942	8.8%
d	33238	6.7%
C	30598	6.1%
r	29740	6.0%
y	28540	5.7%
	28106	5.6%
o	25477	5.1%
h	24947	5.0%
m	22126	4.4%
Other values (23)	163082	32.7%

performance_reserved
Real number (ℝ)

Zeros

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.04594

Minimum	0
Maximum	1
Zeros	47703
Zeros (%)	95.4%
Negative	0
Negative (%)	0.0%
Memory size	781.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2093570945
Coefficient of variation (CV)	4.557185339
Kurtosis	16.81747666
Mean	0.04594
Median Absolute Deviation (MAD)	0
Skewness	4.337834018
Sum	2297
Variance	0.04383039301
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=2)

Value	Count	Frequency (%)
0	47703	95.4%
1	2297	4.6%

Value	Count	Frequency (%)
0	47703	95.4%
1	2297	4.6%

Value	Count	Frequency (%)
1	2297	4.6%
0	47703	95.4%

venue_server_id
Real number (ℝ)

Skewed

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.92188

Minimum	1
Maximum	6914
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	26
Q3	61
95-th percentile	150
Maximum	6914
Range	6913
Interquartile range (IQR)	58

Descriptive statistics

Standard deviation	279.556385
Coefficient of variation (CV)	5.090073119
Kurtosis	526.7163413
Mean	54.92188
Median Absolute Deviation (MAD)	23
Skewness	21.7836194
Sum	2746094
Variance	78151.77241
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
3	10103	20.2%
33	10073	20.1%
1	9427	18.9%
61	6684	13.4%
14	4431	8.9%
26	2172	4.3%
132	1389	2.8%
88	1381	2.8%
231	721	1.4%
34	595	1.2%
Other values (13)	3024	6.0%

Value	Count	Frequency (%)
1	9427	18.9%
3	10103	20.2%
14	4431	8.9%
18	290	0.6%
22	246	0.5%

Value	Count	Frequency (%)
6914	73	0.1%
913	183	0.4%
671	279	0.6%
515	557	1.1%
317	6	< 0.1%

venue_id
Real number (ℝ)

Distinct	170
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	100.20138

Minimum	1
Maximum	1136
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	12
Q3	24
95-th percentile	792
Maximum	1136
Range	1135
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	233.6818017
Coefficient of variation (CV)	2.332121591
Kurtosis	7.39423592
Mean	100.20138
Median Absolute Deviation (MAD)	11
Skewness	2.853681271
Sum	5010069
Variance	54607.18445
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	16335	32.7%
17	4370	8.7%
16	3477	7.0%
24	2387	4.8%
2	1902	3.8%
18	1802	3.6%
19	1740	3.5%
5	1645	3.3%
26	1400	2.8%
4	1229	2.5%
Other values (160)	13713	27.4%

Value	Count	Frequency (%)
1	16335	32.7%
2	1902	3.8%
3	1139	2.3%
4	1229	2.5%
5	1645	3.3%

Value	Count	Frequency (%)
1136	3	< 0.1%
1123	6	< 0.1%
1120	1	< 0.1%
1119	2	< 0.1%
1117	5	< 0.1%

venue
Text

Distinct	214
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	781.2 KiB

Length

Max length	59
Median length	42
Mean length	21.73908
Min length	4

Characters and Unicode

Total characters	1086954
Distinct characters	68
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	< 0.1%

Sample

1st row	Underbelly's Circus Hub on the Meadows
2nd row	Just The Tonic at the Caves
3rd row	Pleasance Courtyard
4th row	Assembly Rooms
5th row	Assembly George Square Gardens

Value	Count	Frequency (%)
square	10087	6.4%
pleasance	10073	6.4%
assembly	10072	6.4%
the	7968	5.1%
courtyard	7130	4.5%
george	6423	4.1%
underbelly	5759	3.7%
	5367	3.4%
gilded	4431	2.8%
balloon	4431	2.8%
Other values (363)	86009	54.5%

Most occurring characters

Value	Count	Frequency (%)
e	133498	12.3%
	109645	10.1%
a	78118	7.2%
l	68311	6.3%
r	65431	6.0%
o	61398	5.6%
s	60886	5.6%
t	45814	4.2%
n	41445	3.8%
d	37371	3.4%
Other values (58)	385037	35.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1086954	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	133498	12.3%
	109645	10.1%
a	78118	7.2%
l	68311	6.3%
r	65431	6.0%
o	61398	5.6%
s	60886	5.6%
t	45814	4.2%
n	41445	3.8%
d	37371	3.4%
Other values (58)	385037	35.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1086954	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	133498	12.3%
	109645	10.1%
a	78118	7.2%
l	68311	6.3%
r	65431	6.0%
o	61398	5.6%
s	60886	5.6%
t	45814	4.2%
n	41445	3.8%
d	37371	3.4%
Other values (58)	385037	35.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1086954	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	133498	12.3%
	109645	10.1%
a	78118	7.2%
l	68311	6.3%
r	65431	6.0%
o	61398	5.6%
s	60886	5.6%
t	45814	4.2%
n	41445	3.8%
d	37371	3.4%
Other values (58)	385037	35.4%

subvenue_id
Real number (ℝ)

Distinct	270
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	192.11278

Minimum	1
Maximum	1723
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	7
median	37
Q3	82
95-th percentile	1366
Maximum	1723
Range	1722
Interquartile range (IQR)	75

Descriptive statistics

Standard deviation	401.7673584
Coefficient of variation (CV)	2.091309898
Kurtosis	5.184974793
Mean	192.11278
Median Absolute Deviation (MAD)	31
Skewness	2.539479865
Sum	9605639
Variance	161417.0102
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3442	6.9%
5	2070	4.1%
2	1713	3.4%
114	1663	3.3%
4	1650	3.3%
14	1647	3.3%
3	1546	3.1%
44	1458	2.9%
60	1242	2.5%
42	1210	2.4%
Other values (260)	32359	64.7%

Value	Count	Frequency (%)
1	3442	6.9%
2	1713	3.4%
3	1546	3.1%
4	1650	3.3%
5	2070	4.1%

Value	Count	Frequency (%)
1723	5	< 0.1%
1720	15	< 0.1%
1719	26	0.1%
1714	3	< 0.1%
1691	6	< 0.1%

subvenue
Text

Distinct	374
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	781.2 KiB

Length

Max length	54
Median length	37
Mean length	11.94828
Min length	2

Characters and Unicode

Total characters	597414
Distinct characters	66
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17 ?
Unique (%)	< 0.1%

Sample

1st row	The Lafayette
2nd row	Just The Big Room
3rd row	Bunker Three
4th row	Music Hall
5th row	Spiegeltent Palais Du Variete

Value	Count	Frequency (%)
hall	6813	6.7%
theatre	6206	6.1%
the	5991	5.9%
studio	3202	3.1%
main	2770	2.7%
room	2733	2.7%
grand	2487	2.4%
pleasance	2446	2.4%
one	1690	1.7%
mcewan	1663	1.6%
Other values (408)	65767	64.6%

Most occurring characters

Value	Count	Frequency (%)
e	68959	11.5%
	53923	9.0%
a	50713	8.5%
n	34417	5.8%
l	33614	5.6%
r	33537	5.6%
t	32708	5.5%
o	31679	5.3%
i	26626	4.5%
h	18485	3.1%
Other values (56)	212753	35.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	597414	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	68959	11.5%
	53923	9.0%
a	50713	8.5%
n	34417	5.8%
l	33614	5.6%
r	33537	5.6%
t	32708	5.5%
o	31679	5.3%
i	26626	4.5%
h	18485	3.1%
Other values (56)	212753	35.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	597414	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	68959	11.5%
	53923	9.0%
a	50713	8.5%
n	34417	5.8%
l	33614	5.6%
r	33537	5.6%
t	32708	5.5%
o	31679	5.3%
i	26626	4.5%
h	18485	3.1%
Other values (56)	212753	35.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	597414	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	68959	11.5%
	53923	9.0%
a	50713	8.5%
n	34417	5.8%
l	33614	5.6%
r	33537	5.6%
t	32708	5.5%
o	31679	5.3%
i	26626	4.5%
h	18485	3.1%
Other values (56)	212753	35.6%

location
Text

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.2 KiB

Length

Max length	39
Median length	3
Mean length	3.8951
Min length	3

Characters and Unicode

Total characters	194755
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Web
2nd row	Web
3rd row	Web
4th row	Web
5th row	Web

Value	Count	Frequency (%)
web	44536	81.5%
counters	1826	3.3%
phones	1601	2.9%
half	1126	2.1%
price	1126	2.1%
hut	1126	2.1%
	583	1.1%
friends	469	0.9%
customer	366	0.7%
services	366	0.7%
Other values (15)	1532	2.8%

Most occurring characters

Value	Count	Frequency (%)
e	51911	26.7%
W	44767	23.0%
b	44536	22.9%
r	4908	2.5%
s	4769	2.4%
	4657	2.4%
n	4374	2.2%
o	4092	2.1%
t	3715	1.9%
u	3497	1.8%
Other values (31)	23529	12.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	194755	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	51911	26.7%
W	44767	23.0%
b	44536	22.9%
r	4908	2.5%
s	4769	2.4%
	4657	2.4%
n	4374	2.2%
o	4092	2.1%
t	3715	1.9%
u	3497	1.8%
Other values (31)	23529	12.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	194755	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	51911	26.7%
W	44767	23.0%
b	44536	22.9%
r	4908	2.5%
s	4769	2.4%
	4657	2.4%
n	4374	2.2%
o	4092	2.1%
t	3715	1.9%
u	3497	1.8%
Other values (31)	23529	12.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	194755	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	51911	26.7%
W	44767	23.0%
b	44536	22.9%
r	4908	2.5%
s	4769	2.4%
	4657	2.4%
n	4374	2.2%
o	4092	2.1%
t	3715	1.9%
u	3497	1.8%
Other values (31)	23529	12.1%

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks